How to Convert a structured Text file to Excel Database ( Transposed)?
Want to have at the Output ,the following:
|Item A||Item B||Item C|
|Data1 A||Data1B||Data1 C|
|Data2 A||Data2B||Data2 C|
|Data3 A||Data3B||Data3 C|
Note : I used to do such activity using “Relative Reference” functionality in excel
Thanks in Advance