extract data from multule rows into one row based on certain criteria

[bohon79]

Good Morning,

Been trying to find a solution to a formula problem but unable to find it and hopefully some can help. Found this forumla online that works great for what i want it to do but for some reason puts a date (1/1/1900) in when the cell its referencing is blank with no date in it. Here is the formula:

=TOROW(FILTER($B$2:$G$496,$A$2:$A$496=A2))

What i am trying to do is take data to consolidate onto on row as is below based on data that is equal. Column A and b will always be constant but c,d,e, will change.:

and convert to

but as you can see it puts a date in when there is no date. Any help in fine tuning the formula to make sure if a date is blank and show blank would be helpful. Also if there is a way for column b to only show up once rather than everytime that would be great as well.

thank you.

 

[Fluff]

In that case can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.