I am looking for Create a template in Excel which can transpose the data I imported from a .txt file. Probably need more than just transpose function.
Attached is the sample text file I need to import .
I created spreadsheet manually, where I am looking for my output to be.
We will be getting these text files every day and want to use a spread sheet to help us easy understand.