View Single Post
  #1   Report Post  
Old December 30th 18, 04:13 AM posted to microsoft.public.excel.programming
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: Dec 2018
Posts: 5
Default covert data from text file into columns

The data is in a text file (amounting to 1.5 M rows) - Sample attached here

Location = "San Bernandino CA"

Store ID = 1
Stock ID = 1
Address = 1001 Parkway Ave
Xroad ID = 1001
ID = 1001

Location = "San Francisco CA"

Store ID = 2
Stock ID = 2
Address = 2001 Morrison Ave
Xroad ID = 2001
ID = 2001

Output should look like:
Location Store ID Stock ID Address Xroad ID ID
San Bernandino
San Francisco

If there is NO Location = " " it is end of row data in the file

since the raw text file is large 1.3M data is running bat file to create csv an option

Thank you