filter values to a merge cells

[ExcelNewbie2020]

Have this table.. i would like to filter the raw data (name and number) and fill it in the expected result table which has a merge cell in it. please see sample table. Many thanks,

TIME SHEETS.xlsx
	A	B	C	D	E	F	G	H	I
1	EXPECTED RESULT							RAW DATA
2	Employee Number	Name						NAME	EMP.#
3	NAME1	1032	A					NAME1	1032
4			B					NAME2	1033
5			C					NAME3	1034
6	NAME2	1033	A					NAME4	1035
7			B					NAME5	1036
8			C					NAME6	1037
9	NAME3	1034	A					NAME7	1038
10			B					NAME8	1039
11			C					NAME9	1040
12	NAME4	1035	A					NAME10	1041
13			B					NAME11	1042
14			C					NAME12	1043
15	NAME5	1036	A					NAME13	1044
16			B					NAME14	1045
17			C					NAME15	1046
18								NAME16	1047
19
20
21
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H3:I18	Expression	=H$7=TODAY()	text	NO
I3:I18	Cell Value	duplicates	text	NO
I3:I18	Cell Value	duplicates	text	NO

 

[arthurbr]

Using Merged Cells Effectively in Excel - Excel Solutions

There's one simple piece of advice for using merged cells effectively in Excel...

excel.solutions