Gather data in a single line

I

imran ashraf

New Member
Joined
Nov 15, 2016
Messages
39
[FONT=&quot] My problem is that each employee appears in the table for each month and I need to gather the data for each employee in a single line.
[/FONT] [TABLE="width: 1250"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Last Name[/TD]
[TD]First Name[/TD]
[TD]Location[/TD]
[TD]Employment Date[/TD]
[TD]Termination Date[/TD]
[TD]1-Mar-2016[/TD]
[TD]1-Apr-2016[/TD]
[TD]1-May-2016[/TD]
[TD]1-Jun-2016[/TD]
[TD]1-Jul-2016[/TD]
[TD]1-Aug-2016[/TD]
[/TR]
[TR]
[TD]ABAZA[/TD]
[TD]VIOREL[/TD]
[TD]VASLUI[/TD]
[TD="align: right"]5/19/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ABAZA[/TD]
[TD]VIOREL[/TD]
[TD]VASLUI[/TD]
[TD="align: right"]5/19/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ABAZA[/TD]
[TD]VIOREL[/TD]
[TD]VASLUI[/TD]
[TD="align: right"]5/19/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ABAZA[/TD]
[TD]VIOREL[/TD]
[TD]VASLUI[/TD]
[TD="align: right"]5/19/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ABAZA[/TD]
[TD]VIOREL[/TD]
[TD]VASLUI[/TD]
[TD="align: right"]5/19/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ABAZA[/TD]
[TD]VIOREL[/TD]
[TD]VASLUI[/TD]
[TD="align: right"]5/19/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ABIBULA[/TD]
[TD]IZMET[/TD]
[TD]CONSTANTA[/TD]
[TD="align: right"]6/4/2015[/TD]
[TD="align: right"]7/16/2016[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]ABIBULA[/TD]
[TD]IZMET[/TD]
[TD]CONSTANTA[/TD]
[TD="align: right"]6/4/2015[/TD]
[TD="align: right"]7/16/2016[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]ABIBULA[/TD]
[TD]IZMET[/TD]
[TD]CONSTANTA[/TD]
[TD="align: right"]6/4/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ABIBULA[/TD]
[TD]IZMET[/TD]
[TD]CONSTANTA[/TD]
[TD="align: right"]6/4/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ABIBULA[/TD]
[TD]IZMET[/TD]
[TD]CONSTANTA[/TD]
[TD="align: right"]6/4/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ACSINIA[/TD]
[TD]CATALIN[/TD]
[TD]BUCURESTI[/TD]
[TD="align: right"]10/24/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]ADAM[/TD]
[TD]CONSTANTIN GHEORGHE[/TD]
[TD]MEHEDINTI[/TD]
[TD="align: right"]5/30/2015[/TD]
[TD="align: right"]6/11/2016[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]ADAM[/TD]
[TD]CONSTANTIN GHEORGHE[/TD]
[TD]MEHEDINTI[/TD]
[TD="align: right"]5/30/2015[/TD]
[TD="align: right"]6/11/2016[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]ADAM[/TD]
[TD]CONSTANTIN GHEORGHE[/TD]
[TD]MEHEDINTI[/TD]
[TD="align: right"]5/30/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]ADAM[/TD]
[TD]CONSTANTIN GHEORGHE[/TD]
[TD]MEHEDINTI[/TD]
[TD="align: right"]5/30/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]AFRIM[/TD]
[TD]IUSTIN-GEORGE[/TD]
[TD]BISTRITA[/TD]
[TD="align: right"]1/1/2016[/TD]
[TD="align: right"]3/2/2016[/TD]
[TD][/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]AIOANEI[/TD]
[TD]IOAN[/TD]
[TD]ROMAN[/TD]
[TD="align: right"]6/6/2015[/TD]
[TD="align: right"]7/1/2016[/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]AIOANEI[/TD]
[TD]IOAN[/TD]
[TD]ROMAN[/TD]
[TD="align: right"]6/6/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]AIOANEI[/TD]
[TD]IOAN[/TD]
[TD]ROMAN[/TD]
[TD="align: right"]6/6/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]AIOANEI[/TD]
[TD]IOAN[/TD]
[TD]ROMAN[/TD]
[TD="align: right"]6/6/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
As long as your most recent date appears at the top, you can use Remove Duplicates for Last Name, First Name combination (possibly also Location and Start Date). Look under the Data -> Data Tools menu.
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Question Question
Modify VBA script to count rows with data in multiple sheets
Replies
0
Views
400
irishjsk
I
P
  • Question Question
ListBox Click to textbox & delete row
Replies
0
Views
592
pure vito
P
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
1K
AndyEd
A
airforceone
  • Solved
Search Row 1 for Text if Found Convert Column to Date
2
Replies
11
Views
1K
airforceone
airforceone
Sufiyan97
  • Solved
VBA Filter Names from List One by One and then Copy filtered data v2
Replies
6
Views
175
Sufiyan97
Sufiyan97

Forum statistics

Threads
1,223,264
Messages
6,171,081
Members
452,377
Latest member
bradfordsam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top