excel - Split a row into several rows while maintaining formulae -

i have table looks this:

id1        |id2      |     month 1   |    month 2    |    month 3    |analysis item number|item type|column1|column2|column1|column2|column1|column2|ac1m1|ac1m2 

the practice has been add each month's data new columns inserted before final analysis. add column in analysis field applying formula of new columns inserted. have other sheets linked data provided in analysis.

as time passes , have more months it's little hectic maintain , not intuitive thinking of changing format this:

item number|item type|column1|column2|month|analysis

the item number , item type duplicated each month , rest of columns unique.

what want change format while maintaining linked formulas, there easy way this? also, best way represent data?

@momobo analysis formula. take 2 types of reading each both automatically , locally, 1 of columns in analysis checks see did reading on particular month. check variance in reading between local reading , automatic reading. report (on separate other pages) tells me how many readings taken each month, items have not been measured , how long has been since last measurement. report directly linked analysis columns not using rest of table anywhere else outside sheet.

@scheballs actual table wide fit here. actual table looks lot posted, differences may number of columns each month greater. if break down each month's sub-column they'll this.

| month1 | | ar1 | lr1 | ar2 | lr2 | date | done | remarks |

ar1, automatic reading first sensor, number.
lr1, local reading first sensor, number.
date, date when reading took place.
done by, person has done reading (assuming local reading available)
remarks, general remarks not feature in analysis @ point.

the analysis column this:

|r1m1|r2m1|v1m1|v2m1|detail|count|

r1m1, binary value, 1 if sensor 1 read on month 1, 0 otherwise.
r2m1, binary value, 1 if sensor 2 read on month 1, 0 otherwise.
v1m1, difference between local , automatic reading sensor 1 on month 1.
v2m1, difference between local , automatic reading sensor 2 on month 1.
count, number of sensors read (either automatically or manually) per month.

yes there easy way - select data in question - control+h - = find & replace.

find "=" , replace "a="

do moving around necessary , select data again , "control+h" , find a= , replace "="

walla!