•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
Our take
If you're looking to enhance your spreadsheet by dynamically generating additional columns based on a specified number, this guide will help you achieve that without using macros. By inputting a number, X, in a designated cell, you can create the desired number of columns next to the original column, effectively copying any formulas present in the original. While exploring functions like SEQUENCE and Power Query may have proven challenging, we'll provide a straightforward approach to meet your requirements seamlessly. Let’s transform your data management experience!
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]
Read on the original site
Open the publisher's page for the full experience