Forum Discussion

LMesi1110's avatar
LMesi1110
Copper Contributor
Mar 28, 2020
Solved

Insert empty row between last names

Dear all,   I have a spreadsheet with a list of training courses for a group of learners. Each learner may have at least 20 courses to take. I would like to place an empty row between each last nam...
excel
  • LMesi1110's avatar
    LMesi1110
    Mar 29, 2020

    Hello and thank youExcelExciting 

     

    I do know how to obtain the design on the left. I want to create the design on the right. I have 86 people with different data  that I want to sort like this and right now I do it manually by inserting an empty row between last names and then highlight each person's data to make reading the report easier. I have multiple reports similar to this that I need to create monthly.

    I am so appreciative of your response to my question!

     

    Kind regards, Lisa Mesi

LMesi1110's avatar
LMesi1110
Copper Contributor
Mar 30, 2020

Thank you so much!SergeiBaklan 

 

This is quite a bit over my head. I am not familiar with Power Query and have done some searching on how to do this. Is there some level 1 training you can recommend to get to the point of following your suggestion?

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 30, 2020

LMesi1110 

That's a lot of different level materials, but what I know and could recommend that's mainly next levels, not basic one.

 

You may start from Excel, in File->New find and open this tutorial

within it will be link on videos related to the tutorial.

  • LMesi1110's avatar
    LMesi1110
    Copper Contributor
    Mar 30, 2020

    Many thanks!SergeiBaklan 

     

    You have provided a direction to learn and apply your recommendation and I really appreciate your quick follow-up!

     

    Have a great day and stay well.

Resources