all records in first column as 7 rows to 7 columns

[miboyfrend]

i have all records in first row consisting of 7 fields i would like them to see in 7 columns each. all records in column A R1 means record 1 F1 means field 1 R1F1 means field one of the first record

r1f1

r1f2

r1f3

r1f4

r1f5

r1f6

r1f7

r2f1

r2f2

r2f3

r2f4

r2f5

r2f6

r2f7


this has to be transposed to


r1f1 r1f2 r1f3 r1f4 r1f5 r1f6 r1f7

r2f1 r2f2 r2f3 r2f4 r2f5 r2f6 r2f7


thanks in advance

 

[NARAYANK991]

Hi ,


Suppose we assume that your input data is on Sheet1 , and you want the transposed data on Sheet2 ; suppose your input data is in column A , starting from cell A2 ; suppose you want the transposed data also to start from cell A2 ; put in the following formula , in cell A2 on Sheet2 , and copy across and down :


=OFFSET(Sheet1!$A$2,((ROW()-ROW($A$2))*7+(COLUMN()-COLUMN($A$2))),INT((COLUMN()-COLUMN($A$2))/7))


Narayan

 

[miboyfrend]

thanks buddy


i used indirect and it was a big circus for me

this is cool but complex used it now and got results

for future trying to decode and understand