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

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]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#natural language processing
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#table
#cells
#data
#text chain