Windows Batch- Convert Row To Column In CSV File

July 25, 2017 at 11:53:46
Specs: Windows 7, 4
I have a an excel file which looks something like this:
A B C Measure Names Measure Values
Business Associate AB Inquiries 30,356
Business Associate ZY Master Lead 5,387
Business Associate XY Shipped Leads 6,430


Here I have written a batch script to achieve the above result in csv file. The final part is I want column 4 and 5 to be pivoted.
So the final output will look like this:

A B C Inquiries Master Lead Shipped Leads
Business Associate AB 0 0 1
Business Associate ZY 0 0 10
Business Associate Xy 0 0 14

Can some one please help me with this. I am not sure how you will do this using batch. Again I need to pivot only the column 4 and 5.

Thanks in advance.

message edited by anksravs


See More: Windows Batch- Convert Row To Column In CSV File

Reply ↓  Report •

#1
July 26, 2017 at 00:17:26
Here in the 1st table column 4 and 5 are : Measure Names and Measure Values from the 1st table.

Reply ↓  Report •

#2
July 27, 2017 at 08:08:42
I'm not sure asking the same question three times over two days is going to encourage anyone to help you, but I've been wrong before. You say batch script, but you're also insistent on Excel, so maybe the Office guys have an answer for you.

How To Ask Questions The Smart Way


Reply ↓  Report •

#3
July 27, 2017 at 09:54:17
I am trying too do this in batch as part of my automation process.

Reply ↓  Report •

Related Solutions

#4
July 27, 2017 at 09:55:53
Also, can I please request the moderator to move this post back to programming and batch section as that is what I am want help with.

Reply ↓  Report •

#5
August 27, 2017 at 03:52:51
do you realy think you'll have right answer after 3rd try? I don't think so...

Reply ↓  Report •

Ask Question