Transposing one column data to different columns based on their headings

**bipindurgapal** · 02-20-2012, 05:59 AM

i, I am attaching herewith data sheet.

I want to transfer single column data to different columns based on their headings which is same as written in that one single column.

Can anyone please try to solve this query as my data is very huge and typing manually can cause error also

**deepansak** · 02-20-2012, 06:05 AM

could you please attach 2003 excel version

Thanks,
Deepan

**watersev** · 02-20-2012, 06:35 AM

hi bipindurgapal, welcome to ExcelForum, please check attachment, VB option, press "Start". It is assumed the header values are known before running the code.