Guys I have been breaking my head for the past three days with this. I really need this to be done.
I need my columns with data pivoted and also have a title column adjacent populated with “column names” for reference.
I did achieve a bit of it but the Do loop is not working for me. You can see it in my attached sample.

This is my data table:
Code:
tblData
id	FName	LName	NumofCars	NumofBikes	NumofVans	TotalCount
...