1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Making a table out of many cells in one line

Our take

Welcome to the community! Converting a single line of cells into a structured table format is a common challenge. In your case, where each space signifies a new cell, you can easily transform your data into a more organized view. By separating each entry based on spaces, you can create a table that enhances readability and usability. Let’s explore how to achieve this transformation effectively, ensuring your data is presented clearly and efficiently.

Hello,

This is my first post and as English is not my first language I couldn't utilise the search bar. Sorry if this ever came up before.

I have cells in one line that I need to convert into a table of sorts. In the example after every space follows a new cell.

I also have the same data as just one text chain.

Example: A 1 2 3 B 3 3 1 C 4 1 2 D 3 2 1

Should become

A 1 2 3

B 3 3 1

C 4 1 2

D 3 2 1

submitted by /u/ManWithTheHex00
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article