•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Generate additional columns in a table based on a number
The original table has minimum no. of columns (1). there is a cell to input a number, say X.
If X=3 then, I need two additional columns to be generated next to the original column. Also, formulae that were there in the original column should be copied to the new columns.
I was looking into SEQUENCE, Power Query etc. but couldn't find a solution. can't use Macros.
the images clarify the requirement
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#cloud-based spreadsheet applications
#additional columns
#input a number
#original table
#formulae
#Excel
#SEQUENCE
#Power Query
#generated columns
#cell
#minimum columns
#can't use Macros
#X=3
#clarify the requirement
#column generation
#copying