SOLVED

Transpose Issue

New Contributor

 

Hi team I have my data as first photo but I want my data column wise like my second  photo. At the end of every address there is a blank cell. Transpose is not working for Multiple address. 

 

 

 

IMG-20220504-WA0002.jpg

IMG-20220504-WA0001.jpg

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@Skpani 

Let's say that you want the "transposed" range to start in cell E5.

Enter the following formula in that cell:

 

=INDEX($A:$A,6*(ROW(E5)-ROW($E$5))+COLUMN(E5)-COLUMN($E$5)+5)&""

 

If you want to start in another cell, change E5 and $E$5 accordingly.

Fill to the next 4 cells to the right, then fill down.

S1389.png

@Hans Vogelaar.. Thanks a lot.. It worked..