I have a list of data that's all in a column
The current format is
Company name
(empty cell)
Street address
City, State, Zip
Phone number
(empty cell)
(empty cell)
REPEAT ABOVE
I have about 1000 rows in this one column. That yields about 165 individual entities. Is there an easy way to convert this data to a table with a header for each of these entries? That way each entities information would be on a single row that becomes sortable? It's less than ideal in the current format. Thanks!
The current format is
Company name
(empty cell)
Street address
City, State, Zip
Phone number
(empty cell)
(empty cell)
REPEAT ABOVE
I have about 1000 rows in this one column. That yields about 165 individual entities. Is there an easy way to convert this data to a table with a header for each of these entries? That way each entities information would be on a single row that becomes sortable? It's less than ideal in the current format. Thanks!