CODEWITHSUNDEEP
excelexcel-formula
DCR
DCR

Reputation: 1

Column Offset Excel Formula

I have an excel spreadsheet with the names in each column; Example

Column A=Name-01, Column B=Name-02, Column C=Name-03 etc

I want to copy the name of each column to another spreadsheet to rows Example

   A1=SheetName Column A=Name-01
   A2=SheetName Column B=Name-02
   A3=SheetName Column C=Name-03

Upvotes: 0

Views: 47

Answers (1)

Scott Craner
Scott Craner

Reputation: 152660

Use INDEX:

=INDEX(Sheet1!$1:$1,ROW(1:1))

Now as you drag it down column A it will refer to the next cell in the first row of the other sheet.

Upvotes: 2

Related Questions