0

I have SSN in 24 tabs all starting in A1. I need all in one tab but copying and pasting seems inefficient.

In Excel is there an easy way to combine the first column in every tab into one long list?

pnuts
  • 58,317
  • 11
  • 87
  • 139
Tim Smith
  • 11
  • 1
  • 1
  • 1
  • I am not sure of a way to do this from plain Excel features. I wrote a program to do this awhile back. I'll be happy to consolidate it for you but I doubt you would send me those SSNs. :) If this is a one time thing, you could download a plugin and use it for the trial period. Something like DigDB http://www.digdb.com/excel_add_ins/join_merge_tables_lists/ – NKD Sep 04 '15 at 17:20
  • 1
    @pnuts I didn't post the code because it would be useless to Tim. I used a paid third party lib to write the code. Hence, I don't think my code qualify as a solution in this case. I tried your answer below and it worked using pivot table. Though this is manual process, it works perfectly if he only needs it once. – NKD Sep 08 '15 at 14:17

1 Answers1

0

Choosing ColumnA and at least one other in each case, please try creating a PivotTable from multiple consolidation ranges. At Step 2b add each pair of columns.

Community
  • 1
  • 1
pnuts
  • 58,317
  • 11
  • 87
  • 139