Word to Excel - Not formatting correctly - Can someone help?

[rgillis32]

Hello All,

I am trying to convert a word document to an excel spreadsheet and I am only having issues. This may be something simple but I cannot figure it out and was wondering if anyone may be able to help me. I am trying to make columns out the first lines and then list the entire document accordingly. My word document looks like this but repeated for about 270 pages:

Service Name
Service ID
License Type
Mailing Street Address
Service Type
Expiration Date
Mailing City, State, Zip Code
Ownership
Level of Care
Emergency Phone
Business Phone
Number of Ambulances
Funding Eligible

Air Methods LLC, wholly owned subsidiary Rocky Mtn Holdings LLC
0767
Certified
6 Old School Road
Ambulance
2/28/2026
Selkirk, NY 12158
Commercial
EMT-P
(800)435-3822
(518)767-9500
0
Y

So if I was to look at the excel I would want "Service Name" in column A followed by "Service ID in column B, etc in Row 1 then continued with "Air Methods..." column A row 2, "0767" column B, etc. Is there a simple way to do this without copy and pasting thousands of entries? Thank you!

 

[hagia_sofia]

Hello, if it is true that there are always 13 column headers and 13 values, I would suggest you to copy all the data from Word to Excel, creating one long column, then delete blank rows between both parts (or any other if there are any) and then use (adjust the range based on your data):

=WRAPROWS(A1:A26,13)

If the data is structured well, you should then only delete the duplicate headers.

 

[rgillis32]

Thank you for the response! I am able to get it to work for the 1st entry but none others after that (with changing range based on data). The data is structured the same throughout the entire document with having 13 lines per component and no other alterations on column value.

 

[hagia_sofia]

Could you post a sample of your data then?

 

[rgillis32]

Could you post a sample of your data then?

Columns:
Service Name
Service ID
License Type
Mailing Street Address
Service Type
Expiration Date
Mailing City, State, Zip Code
Ownership
Level of Care
Emergency Phone
Business Phone
Number of Ambulances
Funding Eligible

Data:
Air Methods LLC, wholly owned subsidiary Rocky Mtn Holdings LLC
0767
Certified
6 Old School Road
Ambulance
2/28/2026
Selkirk, NY 12158
Commercial
EMT-P
(800)435-3822
(518)767-9500
0
Y
Albany County Sheriff's Department Advanced Life Support
0184
Certified
PO Box 315
First Responder
2/28/2026
Voorheesville, NY 12186
Municipal
EMT-P
(518)765-5979
(518)655-7846
0
Y
Albany County Sheriff's Office EMS Unit
6229
Certified
PO Box 315
Ambulance
5/31/2025
Voorheesville, NY 12186
Municipal
EMT
(518)765-5979
(518)655-7846
5
Y
Albany Department of Fire & Emergency Services, City of
0142
Certified
26 Broad Street
First Responder
5/31/2025
Albany, NY 12202
Municipal
EMT-P
(518)438-4000
(518)447-7879
0
Y
Albany-Schenectady-Greene Co. Ag. Societies, Inc.
0139
Certified
PO Box 506
Ambulance
9/30/2025
Altamont, NY 12009
Independent
EMT
911
(518)861-6671
1
Y

Each row ends in Y or N.

 

[hagia_sofia]

When I copy your data to A1:A78 and use:

=WRAPROWS(A1:A78,13)

The data look like as attached...

 

[rgillis32]

When I copy your data to A1:A78 and use:

=WRAPROWS(A1:A78,13)

The data look like as attached...

It looks like excel got the best of me on this one. Looks like I just don't know what I was doing. As soon as I did yours, it worked! Thank you!