Hello dear friends
i am facing a problem in compiling a data. the data i have is an extract from a sheet. the data in question is pertaining to an institute. the data i have is placed leaving few rows blank and data is spread across. it appears as follows:
Date Name From Contact Number Course Paid GST TOTAL
15-04-19 Client1 KNR 7032720820 Basic Beauty Course 1200 216 1416
15-04-19 Client4 KNR 7032720820 Basic Beauty Course 10000 1800 11800
15-04-19 Client6 KNR 7032720820 Moderate Beauty Course 20000 3600 23600
15-04-19 Client9 KNR 7032720820 Advance Beauty Course 40000 7200 47200
15-04-19 Client12 KNR 7032720820 Special Beauty Course 60000 10800 70800
15-04-19 Client15 KNR 7032720820 Advance Beauty Course 40000 7200 47200
what i am to prepare is the data as follows:
Date Name From Contact Number Course Paid GST TOTAL
15-04-19 Client1 KNR 7032720820 Basic Beauty Course 1200 216 1416
15-04-19 Client4 KNR 7032720820 Basic Beauty Course 10000 1800 11800
15-04-19 Client6 KNR 7032720820 Moderate Beauty Course 20000 3600 23600
15-04-19 Client9 KNR 7032720820 Advance Beauty Course 40000 7200 47200
15-04-19 Client12 KNR 7032720820 Special Beauty Course 60000 10800 70800
15-04-19 Client15 KNR 7032720820 Advance Beauty Course 40000 7200 47200
15-04-19 Client18 KNR 7032720820 Advance Beauty Course 40000 7200 47200
15-04-19 Client21 KNR 7032720820 Advance Beauty Course 40000 7200 47200
15-04-19 Client24 KNR 7032720820 Advance Beauty Course 40000 7200 47200
15-04-19 Client27 KNR 7032720820 Advance Beauty Course 40000 7200 47200
15-04-19 Client30 KNR 7032720820 Advance Beauty Course 40000 7200 47200
15-04-19 Client33 KNR 7032720820 Advance Beauty Course 40000 7200 47200
15-04-19 Client36 KNR 7032720820 Advance Beauty Course 40000 7200 47200
I need to bring the data in a continuous form ignoring the blank rows.
advance thanks for the help
Regards
Sriram
Bookmarks