How to convert horizontal excel data to vertical excel data individually

[Srini84 (Srinivas Kadamati)]

@JJ_Mystical

Welcome to community

Check below for your reference

Horizotal data in EXCEL to Vertical data

I’m assuming the Page1 Excel has all the information in the first column. So first thing is you need to know what keywords you are looking for to extract. In this case, you can use basically your column headers that you want. Let us actually store the keywords into a new Data Table with Build Data Table (if you don’t already have an existing spreadsheet. Then, we can use those column headers as your key words. Build Data Table // for example I'll use table called dtNew Then, let’s Read Range …

Hope this helps you

Thanks