I' made something myself but it comes out as a mess. have a look at newspiration.com/news/archive/ and you see what I mean. Below is the template I used but it doesn't give me the result I would like to see; alternating items of two categories on one page. Isn't there a neater way of doing this with perfect result?
<?php
/*
Template Name: twocol_archive
*/
?>
<?php /* get all options: */
include (TEMPLATEPATH . '/functions/bfa_get_options.php');
get_header(); ?>
<div class="txtboxarchive1">
<p><h3>This week's inspiring news</h3></p>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=news&showposts=1');
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_excerpt(); ?>
<?php endwhile; ?>
<?php } ?>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=inspiration&showposts=1');
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_content(); ?><br />
<?php endwhile; ?>
<?php } ?>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=news&showposts=1&offset=1' );
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_excerpt(); ?>
<?php endwhile; ?>
<?php } ?>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=inspiration&showposts=1&of fset=1');
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_content(); ?><br />
<?php endwhile; ?>
<?php } ?>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=news&showposts1&offset=2') ;
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_excerpt(); ?>
<?php endwhile; ?>
<?php } ?>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=inspiration&showposts1&off set=2');
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_content(); ?><br />
<?php endwhile; ?>
<?php } ?>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=news&showposts=1&offset=3' );
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_excerpt(); ?>
<?php endwhile; ?>
<?php } ?>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=inspiration&showposts=1&of fset=3');
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_content(); ?><br />
<?php endwhile; ?>
<?php } ?>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=news&showposts=1&offset=4' );
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_excerpt(); ?>
<?php endwhile; ?>
<?php } ?>
<?php if ( is_page('197') ) { ?>
<?php $my_query = new WP_Query('category_name=inspiration&showposts=1&of fset=4');
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h3><?php the_title(); ?></h3>
<?php the_content(); ?>
<?php endwhile; ?>
<?php } ?>
<?php /* If there are any posts: */
if (have_posts()) : $bfa_ata['postcount'] == 1; /* Postcount needed for option "1 first posts full posts" */ ?>
</div>
<div class="clear"></div>
<?php /* END of: If there are any posts */
else : /* If there are no posts: */ ?>
<?php /* This outputs the "Not Found" content, if neither posts, pages nor attachments are available for the requested page.
This can be edited at Atahualpa Theme Options -> Style & edit the Center column */
bfa_center_content($bfa_ata['content_not_found']); ?>
<?php endif; /* END of: If there are no posts */ ?>
<?php get_footer(); ?>