Hello Experts Exchange
I have a spreadsheet that has a table of data, the has User information going down the left of the row and date information going across.
Is it possible to get the user information and the date information in one row in Excel, so I can import the records into SQL Server?
I have attached how the data is on sheet1 and on sheet2 I have added a example of how I want the data.
If there is someone that can help me to write the macro to get the information the way I want it that would be great.