Transpose data from 1 column to rows

**mukuljain99** · 05-10-2020, 01:16 PM

I want to be able to transpose and distribute a list into different row.

Attaching a sample file of the desired output, any help is appreciated.

**BMV** · 05-10-2020, 02:05 PM

Please Login or Register  to view this content.

**mukuljain99** · 05-10-2020, 02:14 PM

Originally Posted by BMV

Please Login or Register  to view this content.

Getting an error message, not able to work around it.

**BMV** · 05-10-2020, 02:20 PM

Replace semicolon to comma . i have corrected it.

**mukuljain99** · 05-10-2020, 02:36 PM

Originally Posted by BMV

Replace semicolon to comma . i have corrected it.

Thanks, appreciate your help but it's not pulling the data from column A, it's just making a grid of numbers

**Bo_Ry** · 05-10-2020, 02:41 PM

Please try at E3

=IF($D3="Present",INDEX($A$2:$A$36,COUNTIFS($D$2:$D2,"P*")*5+COLUMNS($E3:E3)),"-")

Re: Transpose data from 1 column to rows