1

Is it possible to covert a multiple sheet excel file into one sheet, and have the original sheet name as a column in the final sheet?

So if you have multiple sheet excel A and B where all sheets have the same column names, you combine them, add a column lets call it category and it will have value of A or B.

Can that be done using LibreOffice or gnumeric or any software available on Ubuntu or should I do it programmatically?

Stephen Rauch
  • 1,156
  • 6
  • 15
  • 21
Lynob
  • 6,775

0 Answers0