•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there any way to "unstack" the columns efficiently?
Hello.
I have several excel files with pipe characteristics and want to create a database. However, since the columns are presented this way, I cant create it. I have more than 20 excel files and more than 1000 lines so I need to automate it.
Is there any way to separate the columns so that I have column A, B, C, D... i. e., 8 instead of 4?
The files were created decades ago..
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#financial modeling with spreadsheets
#excel
#unstack
#columns
#database
#pipe characteristics
#automate
#files
#data
#create
#separate
#lines
#A, B, C, D
#automation
#characteristics
#presentation
#format