Converting columns into rows

How many Employees can any Department have?

Does the attached workbook look like your data and expected result?

It is always better to attach a sample workbook.Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

codesearcher,

Welcome to the Excel Forum.

What is the worksheet name that contains the following information?

\current excel data is
dept emp1 sal emp2 sal2 emp3 sal3
HR Abc 123 bcv 231 sjn 987
IT sddds 9876 ds 999 dsb 123

codesearcher,

I assume that your beginning raw data is in the first worksheet (the left most worksheet in the tabs view).

I can also edit the macro code for the correct raw data worksheet name.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ReorgData macro.

codesearcher,

When you respond to someone that is helping you, please use there name/handle, so that we can follow what is going on.

This way the correct helper can respond.

codesearcher,

I still assume that your beginning raw data is in the first worksheet (the left most worksheet in the tabs view).


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ReorgDataV2 macro.

codesearcher,

You are very welcome. Glad I could help.

Thanks for the feedback.

And, come back anytime.