Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 12 September 2019
  0 Replies
  3K Visits
0
Votes
Undo
I have a very large spreadsheet and am looking for the most efficient way to modify the report.  I have employee names in rows, codes in columns and amounts that correspond to the employee and column in the data area. 

Name Salary Vacation Holiday Taxes Insurance 401K
John Smith 1000 80 20 111  5  40
Annie Jones 1500 90 20 152 8  50
Paul Bunyon 3000 0 0 304 15  100
I need to transform the data so it looks like a standard Excel table


NameCodeAmount
John SmithSalary1000
John SmithVacation80
John SmithHoliday20
John SmithTaxes111
John SmithInsurance5
John Smith401K40
Annie Jones Salary1500 (etc...) 


I am easily able to take the amounts and use KUTools > Transform Range > Single Column.  But, how can I get the codes and the names easily?  I have attached an example shown in Excel. The data I have is in columns A-G and what I need to transform it to is in columns K-M
There are no replies made for this post yet.